1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10 using System.Data.SqlClient;
11
12 namespace SoftQuanLyNhaHang.Models
13 {
14 class ThueMod
15 {
16 protected int IdThue {get; set;}
17 protected int Thue {get; set;}
18 protected string TrangThai {get; set;}
19 protected DateTime NgayTao {get; set;}
20
21 public ThueMod(int _IdThue)
22 {
23 IdThue = _IdThue;
24 }
25 public ThueMod()
26 { }
27
28 public ThueMod(int _IdThue, int _Thue, string _TrangThai, DateTime _NgayTao)
29 {
30 IdThue = _IdThue;
31 Thue = _Thue;
32 TrangThai = _TrangThai;
33 NgayTao = _NgayTao;
34
35 }
36
37 public int InsertThue()
38 {
39 int i = 0;
40 string[] paras = new string[4] { "@IdThue", "@Thue", "@TrangThai", "@NgayTao"};
41 object[] values = new object[4] { IdThue, Thue, TrangThai, NgayTao};
42 i = Models.connection.Excute_Sql("tbl_Thue_Insert", CommandType.StoredProcedure, paras, values);
43 return i;
44 }
45
46 public int UpdateThue()
47 {
48 int i = 0;
49 string[] paras = new string[4] { "@IdThue", "@Thue", "@TrangThai", "@NgayTao" };
50 object[] values = new object[4] { IdThue, Thue, TrangThai, NgayTao };
51 i = Models.connection.Excute_Sql("tbl_Thue_Update", CommandType.StoredProcedure, paras, values);
52 return i;
53 }
54
55 public int DeleteThue()
56 {
57 int i = 0;
58 string[] paras = new string[1] { "@IdThue" };
59 object[] values = new object[1] { IdThue };
60 i = Models.connection.Excute_Sql("tbl_Thue_Delete", CommandType.StoredProcedure, paras, values);
61 return i;
62 }
63
64 //
65 public DataSet FillDataSetThue_GetShowDropdow()
66 {
67 DataSet ds = new DataSet();
68 ds = Models.connection.FillDataSet("tbl_Thue_GetsShowDrop", CommandType.StoredProcedure);
69 return ds;
70 }
71
72 }
73 }